Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_ATTRIBUTE_TRANSFORMATIONS

`DBA_ATTRIBUTE_TRANSFORMATIONS` displays information about the transformation functions for all transformations in the database.

Related View

`USER_ATTRIBUTE_TRANSFORMATIONS` displays information about the transformation functions for the transformations owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`TRANSFORMATION_ID` | `NUMBER` | `NOT NULL` | Unique identifier for the transformation
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owning user of the transformation
`NAME` | `VARCHAR2(30)` | `NOT NULL` | Transformation name
`FROM_TYPE` | `VARCHAR2(61)` |  | Source type name
`TO_TYPE` | `VARCHAR2(91)` |  | Target type name
`ATTRIBUTE` | `NUMBER` | `NOT NULL` | Target type attribute number
`ATTRIBUTE_TRANSFORMATION` | `VARCHAR2(4000)` |  | Transformation function for the attribute

See Also: "USER_ATTRIBUTE_TRANSFORMATIONS"